package com.zyit.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zyit.pojo.Department;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DepartmentMapper extends BaseMapper<Department> {
    @Select("select bigcode,bigname from department where hoscode = #{hoscode}")
    List<Department> findBigDepartments(String hoscode);

    @Select("select depcode,depname from department where bigcode = #{bigcode}")
    List<Department> findDepartments(String bigcode);
}
